<html><head><title>ParseDate</title></head>
<body bgcolor="#FFFFDF" link="#009999" vlink="#006666" alink="#006666">
<font face="Arial" size="2"><p align="center"><b><font size="4">ParseDate()</font></b></p>
<p><b>Syntax</b></p><blockquote>
Date = <font color="#006666"><b>ParseDate</b></font>(Mask$, String$)</blockquote>

</blockquote>
<b>Description</b><br><blockquote>

Transforms a string date into a regular date value which then can be used by other date functions. 

</blockquote><p><b>Parameters</b></p><blockquote>
<style type="text/css">
table.parameters { border-spacing: 0px; border-style: none; border-collapse: collapse; }
table.parameters td { border-width: 1px; padding: 6px; border-style: solid; border-color: gray; vertical-align: top; font-family:Arial; font-size:10pt; }
</style>
<table width="90%" class="parameters">
<tr><td width="10%"><i>Mask$</i></td>
<td width="90%"> 
A mask string which defines how the date string is formatted. Possible tokens are: 
<pre><font face="Courier New, Courier, mono"size="2">  %yyyy: Will be replaced by the year value, on 4 digits.
  %yy: Will be replaced by the year value, on 2 digits.
  %mm: Will be replaced by the month value, on 2 digits.
  %dd: Will be replaced by the day value, on 2 digits.
  %hh: Will be replaced by the hour value, on 2 digits.
  %ii: Will be replaced by the minute value, on 2 digits.
  %ss: Will be replaced by the second value, on 2 digits.
</font></pre>

</td></tr>
<tr><td><i>String$</i></td>
<td> 
The string with the date to be parsed. 

</td></tr>
</table>
</blockquote><p><b>Return value</b></p><blockquote>

Returns the date representing the parsed string. If the input string did not match the mask 
then the result is -1. 

</blockquote><p><b>Example</b></p><blockquote>

<pre><font face="Courier New, Courier, mono"size="2">
  <b><font color="#006666">Debug</font></b> <font color="#006666">ParseDate</font>("%yy/%mm/%dd", "10/01/07")     <font color="#006666">; Returns the date value of "10/01/07"</font>

  <b><font color="#006666">Debug</font></b> <font color="#006666">ParseDate</font>("%mm/%dd/%yyyy", "01/07/2010") <font color="#006666">; Returns the date value of "01/07/2010"</font>

</font></pre>

</blockquote><p><b>See Also</b></p><blockquote>

<a href="date.html">Date()</a>, <a href="formatdate.html">FormatDate()</a> 

</Blockquote><p><b>Supported OS </b><Blockquote>All</Blockquote></p><center><- <a href=month.html>Month()</a> - <a href=index.html>Date Index</a> - <a href=second.html>Second()</a> ->
</body></html>